Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Connecting through ORACLE Networking

ORACLE network interfaces allow you to access an ORACLE RDBMS instance running on a remote machine. You do not need any OpenEdge-supplied software on the machine where ORACLE is running. However, you need ORACLE Networking installed on the client machine and an ORACLE Listener on the machine where the ORACLE instance is running.

To access an ORACLE distributed database, you connect through ORACLE Networking, just as you would connect to a single instance. The DataServer detects all the links that make up the distributed database. DataServer access to a distributed database is transparent and requires no additional commands or startup parameters.

To connect to an ORACLE instance through ORACLE Networking:
  1. Make sure that the remote ORACLE instance is running.

  2. Make sure that ORACLE Networking is running on the client machine.

  3. Supply the following connection parameters in your OpenEdge startup command or parameter file, depending on the platform and configuration:

    1. For a Windows client on an ORACLE Networking, enter this command:

      2. prowin32 schema-holder-name -RO -db oracle-dbname
  -U userid@service-name -P password

    2. For a UNIX client on an ORACLE Networking, enter this command:

      3. pro schema-holder-name -db oracle-dbname
  -U userid@service-name -P password

      For example, the following command starts OpenEdge on a UNIX machine, connects a local schema holder oholder in read-only mode and connects the remote ORACLE instance orademo and uses the service oserviceA. The username is scott and the password is tiger, as shown: 

      pro oholder -RO -db oradb -U scott@oserviceA -P tiger

      If you are connected through ORACLE Networking, the OpenEdge USERID function returns scott@oserviceA, instead of just scott.

If you use ORACLE Networking, the service name must be part of the username or password. You can use one of these forms: 

CONNECT <logical name> -U <user@service-name> -P <password> 
CONNECT <logical name> -U <user/password@service-name> 

CONNECT <logical name> -U <user> -P <password@service-name>

Copyright © 2005 Progress Software Corporation
 www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095